Overview
Dataset statistics
| Number of variables | 35 |
|---|---|
| Number of observations | 86971 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 23.2 MiB |
| Average record size in memory | 280.0 B |
Variable types
| Numeric | 13 |
|---|---|
| Text | 10 |
| Categorical | 9 |
| DateTime | 3 |
address_id is highly overall correlated with customer_id and 1 other fields | High correlation |
amount is highly overall correlated with rental_rate | High correlation |
customer_id is highly overall correlated with address_id and 1 other fields | High correlation |
film_id is highly overall correlated with inventory_id | High correlation |
inventory_id is highly overall correlated with film_id | High correlation |
payment_id is highly overall correlated with address_id and 1 other fields | High correlation |
rental_rate is highly overall correlated with amount | High correlation |
staff_fn is highly overall correlated with staff_id and 2 other fields | High correlation |
staff_id is highly overall correlated with staff_fn and 2 other fields | High correlation |
staff_ln is highly overall correlated with staff_fn and 2 other fields | High correlation |
store_id is highly overall correlated with staff_fn and 2 other fields | High correlation |
active is highly imbalanced (82.7%) | Imbalance |
Reproduction
| Analysis started | 2026-01-14 07:00:40.176811 |
|---|---|
| Analysis finished | 2026-01-14 07:00:54.499272 |
| Duration | 14.32 seconds |
| Software version | ydata-profiling vv4.18.1 |
| Download configuration | config.json |
Variables
film_id
Real number (ℝ)
High correlation
| Distinct | 955 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 502.29349 |
| Minimum | 1 |
|---|---|
| Maximum | 1000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 48 |
| Q1 | 256 |
| median | 496 |
| Q3 | 752 |
| 95-th percentile | 952 |
| Maximum | 1000 |
| Range | 999 |
| Interquartile range (IQR) | 496 |
Descriptive statistics
| Standard deviation | 288.20778 |
|---|---|
| Coefficient of variation (CV) | 0.57378364 |
| Kurtosis | -1.1859664 |
| Mean | 502.29349 |
| Median Absolute Deviation (MAD) | 247 |
| Skewness | -0.011599022 |
| Sum | 43684967 |
| Variance | 83063.727 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 489 | 279 | 0.3% |
| 880 | 275 | 0.3% |
| 249 | 273 | 0.3% |
| 649 | 264 | 0.3% |
| 892 | 252 | 0.3% |
| 764 | 252 | 0.3% |
| 418 | 248 | 0.3% |
| 369 | 248 | 0.3% |
| 301 | 243 | 0.3% |
| 414 | 240 | 0.3% |
| Other values (945) | 84397 |
| Value | Count | Frequency (%) |
| 1 | 220 | |
| 2 | 24 | < 0.1% |
| 3 | 60 | 0.1% |
| 4 | 110 | |
| 5 | 55 | 0.1% |
| 6 | 147 | |
| 7 | 75 | 0.1% |
| 8 | 72 | 0.1% |
| 9 | 108 | |
| 10 | 184 |
| Value | Count | Frequency (%) |
| 1000 | 93 | |
| 999 | 85 | |
| 998 | 48 | 0.1% |
| 997 | 30 | < 0.1% |
| 996 | 35 | < 0.1% |
| 995 | 23 | < 0.1% |
| 994 | 78 | |
| 993 | 180 | |
| 992 | 56 | 0.1% |
| 991 | 64 | 0.1% |
title
Text
| Distinct | 955 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
Length
| Max length | 27 |
|---|---|
| Median length | 22 |
| Mean length | 14.315887 |
| Min length | 8 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BLANKET BEVERLY |
|---|---|
| 2nd row | BLANKET BEVERLY |
| 3rd row | BLANKET BEVERLY |
| 4th row | BLANKET BEVERLY |
| 5th row | FREAKY POCUS |
| Value | Count | Frequency (%) |
| heartbreakers | 659 | 0.4% |
| hellfighters | 642 | 0.4% |
| armageddon | 636 | 0.4% |
| boondock | 631 | 0.4% |
| apollo | 611 | 0.4% |
| polish | 592 | 0.3% |
| desire | 563 | 0.3% |
| shakespeare | 562 | 0.3% |
| instinct | 558 | 0.3% |
| love | 548 | 0.3% |
| Other values (974) | 167940 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 123364 | 9.9% |
| A | 105035 | 8.4% |
| R | 91026 | 7.3% |
| O | 87779 | 7.1% |
| 86971 | 7.0% | |
| N | 82351 | 6.6% |
| I | 82017 | 6.6% |
| S | 77792 | 6.2% |
| T | 72061 | 5.8% |
| L | 59662 | 4.8% |
| Other values (17) | 377009 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1158096 | |
| Space Separator | 86971 | 7.0% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 123364 | 10.7% |
| A | 105035 | 9.1% |
| R | 91026 | 7.9% |
| O | 87779 | 7.6% |
| N | 82351 | 7.1% |
| I | 82017 | 7.1% |
| S | 77792 | 6.7% |
| T | 72061 | 6.2% |
| L | 59662 | 5.2% |
| C | 47369 | 4.1% |
| Other values (16) | 329640 |
Space Separator
| Value | Count | Frequency (%) |
| 86971 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1158096 | |
| Common | 86971 | 7.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 123364 | 10.7% |
| A | 105035 | 9.1% |
| R | 91026 | 7.9% |
| O | 87779 | 7.6% |
| N | 82351 | 7.1% |
| I | 82017 | 7.1% |
| S | 77792 | 6.7% |
| T | 72061 | 6.2% |
| L | 59662 | 5.2% |
| C | 47369 | 4.1% |
| Other values (16) | 329640 |
Common
| Value | Count | Frequency (%) |
| 86971 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1245067 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 123364 | 9.9% |
| A | 105035 | 8.4% |
| R | 91026 | 7.3% |
| O | 87779 | 7.1% |
| 86971 | 7.0% | |
| N | 82351 | 6.6% |
| I | 82017 | 6.6% |
| S | 77792 | 6.2% |
| T | 72061 | 5.8% |
| L | 59662 | 4.8% |
| Other values (17) | 377009 |
description
Text
| Distinct | 955 |
|---|---|
| Distinct (%) | 1.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
Length
| Max length | 130 |
|---|---|
| Median length | 115 |
| Mean length | 94.315335 |
| Min length | 70 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria |
|---|---|
| 2nd row | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria |
| 3rd row | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria |
| 4th row | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria |
| 5th row | A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico |
| Value | Count | Frequency (%) |
| a | 384073 | |
| of | 89982 | 5.6% |
| and | 86971 | 5.4% |
| who | 86971 | 5.4% |
| must | 86971 | 5.4% |
| in | 86971 | 5.4% |
| the | 16699 | 1.0% |
| mad | 15668 | 1.0% |
| shark | 10557 | 0.7% |
| boat | 10228 | 0.6% |
| Other values (139) | 723265 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1511385 | ||
| a | 718977 | 8.8% |
| n | 565473 | 6.9% |
| o | 502463 | 6.1% |
| e | 490408 | 6.0% |
| t | 468027 | 5.7% |
| i | 416232 | 5.1% |
| r | 335873 | 4.1% |
| s | 295545 | 3.6% |
| A | 282804 | 3.4% |
| Other values (42) | 2615512 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 5657078 | |
| Space Separator | 1511385 | 18.4% |
| Uppercase Letter | 1017316 | 12.4% |
| Dash Punctuation | 16920 | 0.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 718977 | |
| n | 565473 | |
| o | 502463 | 8.9% |
| e | 490408 | 8.7% |
| t | 468027 | 8.3% |
| i | 416232 | 7.4% |
| r | 335873 | 5.9% |
| s | 295545 | 5.2% |
| u | 269218 | 4.8% |
| h | 206132 | 3.6% |
| Other values (16) | 1388730 |
Uppercase Letter
| Value | Count | Frequency (%) |
| A | 282804 | |
| S | 101761 | 10.0% |
| C | 84099 | 8.3% |
| M | 68893 | 6.8% |
| D | 60784 | 6.0% |
| B | 58596 | 5.8% |
| T | 56809 | 5.6% |
| F | 56157 | 5.5% |
| P | 46203 | 4.5% |
| W | 32559 | 3.2% |
| Other values (14) | 168651 |
Space Separator
| Value | Count | Frequency (%) |
| 1511385 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 16920 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 6674394 | |
| Common | 1528305 | 18.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 718977 | 10.8% |
| n | 565473 | 8.5% |
| o | 502463 | 7.5% |
| e | 490408 | 7.3% |
| t | 468027 | 7.0% |
| i | 416232 | 6.2% |
| r | 335873 | 5.0% |
| s | 295545 | 4.4% |
| A | 282804 | 4.2% |
| u | 269218 | 4.0% |
| Other values (40) | 2329374 |
Common
| Value | Count | Frequency (%) |
| 1511385 | ||
| - | 16920 | 1.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 8202699 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1511385 | ||
| a | 718977 | 8.8% |
| n | 565473 | 6.9% |
| o | 502463 | 6.1% |
| e | 490408 | 6.0% |
| t | 468027 | 5.7% |
| i | 416232 | 5.1% |
| r | 335873 | 4.1% |
| s | 295545 | 3.6% |
| A | 282804 | 3.4% |
| Other values (42) | 2615512 |
rental_duration
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
| 6 | |
|---|---|
| 4 | |
| 3 | |
| 5 | |
| 7 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 7 |
|---|---|
| 2nd row | 7 |
| 3rd row | 7 |
| 4th row | 7 |
| 5th row | 7 |
Common Values
| Value | Count | Frequency (%) |
| 6 | 19042 | |
| 4 | 18450 | |
| 3 | 17938 | |
| 5 | 17358 | |
| 7 | 14183 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 6 | 19042 | |
| 4 | 18450 | |
| 3 | 17938 | |
| 5 | 17358 | |
| 7 | 14183 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 19042 | |
| 4 | 18450 | |
| 3 | 17938 | |
| 5 | 17358 | |
| 7 | 14183 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 86971 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 19042 | |
| 4 | 18450 | |
| 3 | 17938 | |
| 5 | 17358 | |
| 7 | 14183 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 86971 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 19042 | |
| 4 | 18450 | |
| 3 | 17938 | |
| 5 | 17358 | |
| 7 | 14183 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 86971 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6 | 19042 | |
| 4 | 18450 | |
| 3 | 17938 | |
| 5 | 17358 | |
| 7 | 14183 |
rental_rate
Categorical
High correlation
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
| 0.99 | |
|---|---|
| 2.99 | |
| 4.99 |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 4 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 2.99 |
|---|---|
| 2nd row | 2.99 |
| 3rd row | 2.99 |
| 4th row | 2.99 |
| 5th row | 2.99 |
Common Values
| Value | Count | Frequency (%) |
| 0.99 | 30746 | |
| 2.99 | 28626 | |
| 4.99 | 27599 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 0.99 | 30746 | |
| 2.99 | 28626 | |
| 4.99 | 27599 |
Most occurring characters
| Value | Count | Frequency (%) |
| 9 | 173942 | |
| . | 86971 | |
| 0 | 30746 | 8.8% |
| 2 | 28626 | 8.2% |
| 4 | 27599 | 7.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 260913 | |
| Other Punctuation | 86971 | 25.0% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 9 | 173942 | |
| 0 | 30746 | 11.8% |
| 2 | 28626 | 11.0% |
| 4 | 27599 | 10.6% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 86971 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 347884 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 9 | 173942 | |
| . | 86971 | |
| 0 | 30746 | 8.8% |
| 2 | 28626 | 8.2% |
| 4 | 27599 | 7.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 347884 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 9 | 173942 | |
| . | 86971 | |
| 0 | 30746 | 8.8% |
| 2 | 28626 | 8.2% |
| 4 | 27599 | 7.9% |
length
Real number (ℝ)
| Distinct | 140 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 115.15425 |
| Minimum | 46 |
|---|---|
| Maximum | 185 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 46 |
|---|---|
| 5-th percentile | 52 |
| Q1 | 80 |
| median | 114 |
| Q3 | 150 |
| 95-th percentile | 178 |
| Maximum | 185 |
| Range | 139 |
| Interquartile range (IQR) | 70 |
Descriptive statistics
| Standard deviation | 40.508461 |
|---|---|
| Coefficient of variation (CV) | 0.35177566 |
| Kurtosis | -1.1983035 |
| Mean | 115.15425 |
| Median Absolute Deviation (MAD) | 35 |
| Skewness | 0.026121438 |
| Sum | 10015080 |
| Variance | 1640.9354 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 85 | 1465 | 1.7% |
| 178 | 1352 | 1.6% |
| 112 | 1345 | 1.5% |
| 84 | 1178 | 1.4% |
| 80 | 1062 | 1.2% |
| 63 | 1062 | 1.2% |
| 75 | 1056 | 1.2% |
| 92 | 1028 | 1.2% |
| 179 | 1008 | 1.2% |
| 161 | 1000 | 1.1% |
| Other values (130) | 75415 |
| Value | Count | Frequency (%) |
| 46 | 580 | |
| 47 | 724 | |
| 48 | 828 | |
| 49 | 351 | |
| 50 | 557 | |
| 51 | 631 | |
| 52 | 682 | |
| 53 | 743 | |
| 54 | 515 | |
| 55 | 336 |
| Value | Count | Frequency (%) |
| 185 | 936 | |
| 184 | 366 | 0.4% |
| 183 | 417 | 0.5% |
| 182 | 251 | 0.3% |
| 181 | 817 | |
| 180 | 376 | 0.4% |
| 179 | 1008 | |
| 178 | 1352 | |
| 177 | 660 | |
| 176 | 885 |
replacement_cost
Real number (ℝ)
| Distinct | 21 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.199909 |
| Minimum | 9.99 |
|---|---|
| Maximum | 29.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 9.99 |
|---|---|
| 5-th percentile | 10.99 |
| Q1 | 14.99 |
| median | 20.99 |
| Q3 | 25.99 |
| 95-th percentile | 29.99 |
| Maximum | 29.99 |
| Range | 20 |
| Interquartile range (IQR) | 11 |
Descriptive statistics
| Standard deviation | 6.0907494 |
|---|---|
| Coefficient of variation (CV) | 0.3015236 |
| Kurtosis | -1.2239214 |
| Mean | 20.199909 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | -0.037070367 |
| Sum | 1756806.3 |
| Variance | 37.097228 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 22.99 | 5561 | 6.4% |
| 27.99 | 5168 | 5.9% |
| 12.99 | 4964 | 5.7% |
| 21.99 | 4845 | 5.6% |
| 14.99 | 4818 | 5.5% |
| 29.99 | 4660 | 5.4% |
| 20.99 | 4620 | 5.3% |
| 26.99 | 4226 | 4.9% |
| 13.99 | 4146 | 4.8% |
| 11.99 | 4100 | 4.7% |
| Other values (11) | 39863 |
| Value | Count | Frequency (%) |
| 9.99 | 3888 | |
| 10.99 | 3482 | |
| 11.99 | 4100 | |
| 12.99 | 4964 | |
| 13.99 | 4146 | |
| 14.99 | 4818 | |
| 15.99 | 3123 | |
| 16.99 | 3557 | |
| 17.99 | 3692 | |
| 18.99 | 3661 |
| Value | Count | Frequency (%) |
| 29.99 | 4660 | |
| 28.99 | 4046 | |
| 27.99 | 5168 | |
| 26.99 | 4226 | |
| 25.99 | 3668 | |
| 24.99 | 3383 | |
| 23.99 | 3835 | |
| 22.99 | 5561 | |
| 21.99 | 4845 | |
| 20.99 | 4620 |
rating
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
| PG-13 | |
|---|---|
| PG | |
| NC-17 | |
| R | |
| G |
Length
| Max length | 5 |
|---|---|
| Median length | 2 |
| Mean length | 2.8783618 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | G |
|---|---|
| 2nd row | G |
| 3rd row | G |
| 4th row | G |
| 5th row | R |
Common Values
| Value | Count | Frequency (%) |
| PG-13 | 18850 | |
| PG | 18411 | |
| NC-17 | 17388 | |
| R | 17053 | |
| G | 15269 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| pg-13 | 18850 | |
| pg | 18411 | |
| nc-17 | 17388 | |
| r | 17053 | |
| g | 15269 |
Most occurring characters
| Value | Count | Frequency (%) |
| G | 52530 | |
| P | 37261 | |
| - | 36238 | |
| 1 | 36238 | |
| 3 | 18850 | 7.5% |
| N | 17388 | 6.9% |
| C | 17388 | 6.9% |
| 7 | 17388 | 6.9% |
| R | 17053 | 6.8% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 141620 | |
| Decimal Number | 72476 | |
| Dash Punctuation | 36238 | 14.5% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 52530 | |
| P | 37261 | |
| N | 17388 | 12.3% |
| C | 17388 | 12.3% |
| R | 17053 | 12.0% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 36238 | |
| 3 | 18850 | |
| 7 | 17388 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 36238 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 141620 | |
| Common | 108714 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| G | 52530 | |
| P | 37261 | |
| N | 17388 | 12.3% |
| C | 17388 | 12.3% |
| R | 17053 | 12.0% |
Common
| Value | Count | Frequency (%) |
| - | 36238 | |
| 1 | 36238 | |
| 3 | 18850 | |
| 7 | 17388 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 250334 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| G | 52530 | |
| P | 37261 | |
| - | 36238 | |
| 1 | 36238 | |
| 3 | 18850 | 7.5% |
| N | 17388 | 6.9% |
| C | 17388 | 6.9% |
| 7 | 17388 | 6.9% |
| R | 17053 | 6.8% |
actor_id
Real number (ℝ)
| Distinct | 200 |
|---|---|
| Distinct (%) | 0.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 100.9395 |
| Minimum | 1 |
|---|---|
| Maximum | 200 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 52 |
| median | 102 |
| Q3 | 149 |
| 95-th percentile | 191 |
| Maximum | 200 |
| Range | 199 |
| Interquartile range (IQR) | 97 |
Descriptive statistics
| Standard deviation | 56.883288 |
|---|---|
| Coefficient of variation (CV) | 0.56353845 |
| Kurtosis | -1.1741743 |
| Mean | 100.9395 |
| Median Absolute Deviation (MAD) | 48 |
| Skewness | 0.0025358136 |
| Sum | 8778809 |
| Variance | 3235.7084 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 107 | 742 | 0.9% |
| 181 | 664 | 0.8% |
| 198 | 663 | 0.8% |
| 144 | 645 | 0.7% |
| 102 | 632 | 0.7% |
| 60 | 608 | 0.7% |
| 150 | 602 | 0.7% |
| 37 | 598 | 0.7% |
| 23 | 593 | 0.7% |
| 90 | 588 | 0.7% |
| Other values (190) | 80636 |
| Value | Count | Frequency (%) |
| 1 | 301 | |
| 2 | 384 | |
| 3 | 308 | |
| 4 | 272 | |
| 5 | 490 | |
| 6 | 273 | |
| 7 | 476 | |
| 8 | 314 | |
| 9 | 376 | |
| 10 | 355 |
| Value | Count | Frequency (%) |
| 200 | 339 | |
| 199 | 248 | 0.3% |
| 198 | 663 | |
| 197 | 546 | |
| 196 | 450 | |
| 195 | 443 | |
| 194 | 378 | |
| 193 | 438 | |
| 192 | 452 | |
| 191 | 515 |
actor_fn
Text
| Distinct | 128 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 8 |
| Mean length | 5.3014798 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | FRED |
|---|---|
| 2nd row | ALAN |
| 3rd row | BURT |
| 4th row | THORA |
| 5th row | TOM |
| Value | Count | Frequency (%) |
| penelope | 1637 | 1.9% |
| kenneth | 1625 | 1.9% |
| jayne | 1544 | 1.8% |
| matthew | 1496 | 1.7% |
| julia | 1414 | 1.6% |
| groucho | 1333 | 1.5% |
| morgan | 1322 | 1.5% |
| ed | 1295 | 1.5% |
| burt | 1291 | 1.5% |
| christian | 1271 | 1.5% |
| Other values (118) | 72743 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 64486 | |
| A | 52085 | 11.3% |
| R | 40638 | 8.8% |
| N | 40267 | 8.7% |
| L | 29241 | 6.3% |
| I | 29081 | 6.3% |
| O | 18393 | 4.0% |
| S | 18364 | 4.0% |
| T | 17941 | 3.9% |
| C | 17009 | 3.7% |
| Other values (14) | 133570 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 461075 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 64486 | |
| A | 52085 | 11.3% |
| R | 40638 | 8.8% |
| N | 40267 | 8.7% |
| L | 29241 | 6.3% |
| I | 29081 | 6.3% |
| O | 18393 | 4.0% |
| S | 18364 | 4.0% |
| T | 17941 | 3.9% |
| C | 17009 | 3.7% |
| Other values (14) | 133570 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 461075 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 64486 | |
| A | 52085 | 11.3% |
| R | 40638 | 8.8% |
| N | 40267 | 8.7% |
| L | 29241 | 6.3% |
| I | 29081 | 6.3% |
| O | 18393 | 4.0% |
| S | 18364 | 4.0% |
| T | 17941 | 3.9% |
| C | 17009 | 3.7% |
| Other values (14) | 133570 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 461075 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 64486 | |
| A | 52085 | 11.3% |
| R | 40638 | 8.8% |
| N | 40267 | 8.7% |
| L | 29241 | 6.3% |
| I | 29081 | 6.3% |
| O | 18393 | 4.0% |
| S | 18364 | 4.0% |
| T | 17941 | 3.9% |
| C | 17009 | 3.7% |
| Other values (14) | 133570 |
actor_ln
Text
| Distinct | 121 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 9 |
| Mean length | 6.2449207 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | COSTNER |
|---|---|
| 2nd row | DREYFUSS |
| 3rd row | TEMPLE |
| 4th row | TEMPLE |
| 5th row | MIRANDA |
| Value | Count | Frequency (%) |
| kilmer | 2124 | 2.4% |
| nolte | 2090 | 2.4% |
| temple | 1756 | 2.0% |
| degeneres | 1593 | 1.8% |
| keitel | 1564 | 1.8% |
| berry | 1464 | 1.7% |
| torn | 1459 | 1.7% |
| hoffman | 1444 | 1.7% |
| guiness | 1407 | 1.6% |
| garland | 1379 | 1.6% |
| Other values (111) | 70691 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 67826 | |
| N | 44339 | 8.2% |
| R | 40636 | 7.5% |
| A | 39274 | 7.2% |
| O | 39205 | 7.2% |
| L | 39012 | 7.2% |
| I | 33562 | 6.2% |
| S | 31932 | 5.9% |
| T | 23352 | 4.3% |
| D | 21252 | 3.9% |
| Other values (17) | 162737 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 542645 | |
| Dash Punctuation | 482 | 0.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 67826 | |
| N | 44339 | 8.2% |
| R | 40636 | 7.5% |
| A | 39274 | 7.2% |
| O | 39205 | 7.2% |
| L | 39012 | 7.2% |
| I | 33562 | 6.2% |
| S | 31932 | 5.9% |
| T | 23352 | 4.3% |
| D | 21252 | 3.9% |
| Other values (16) | 162255 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 482 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 542645 | |
| Common | 482 | 0.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 67826 | |
| N | 44339 | 8.2% |
| R | 40636 | 7.5% |
| A | 39274 | 7.2% |
| O | 39205 | 7.2% |
| L | 39012 | 7.2% |
| I | 33562 | 6.2% |
| S | 31932 | 5.9% |
| T | 23352 | 4.3% |
| D | 21252 | 3.9% |
| Other values (16) | 162255 |
Common
| Value | Count | Frequency (%) |
| - | 482 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 543127 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 67826 | |
| N | 44339 | 8.2% |
| R | 40636 | 7.5% |
| A | 39274 | 7.2% |
| O | 39205 | 7.2% |
| L | 39012 | 7.2% |
| I | 33562 | 6.2% |
| S | 31932 | 5.9% |
| T | 23352 | 4.3% |
| D | 21252 | 3.9% |
| Other values (17) | 162737 |
customer_id
Real number (ℝ)
High correlation
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 297.3076 |
| Minimum | 1 |
|---|---|
| Maximum | 599 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 29 |
| Q1 | 148 |
| median | 296 |
| Q3 | 446 |
| 95-th percentile | 568 |
| Maximum | 599 |
| Range | 598 |
| Interquartile range (IQR) | 298 |
Descriptive statistics
| Standard deviation | 172.18532 |
|---|---|
| Coefficient of variation (CV) | 0.57914873 |
| Kurtosis | -1.1879078 |
| Mean | 297.3076 |
| Median Absolute Deviation (MAD) | 149 |
| Skewness | 0.0073978278 |
| Sum | 25857139 |
| Variance | 29647.783 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 148 | 272 | 0.3% |
| 526 | 251 | 0.3% |
| 197 | 244 | 0.3% |
| 144 | 239 | 0.3% |
| 236 | 225 | 0.3% |
| 257 | 221 | 0.3% |
| 29 | 217 | 0.2% |
| 178 | 217 | 0.2% |
| 75 | 212 | 0.2% |
| 506 | 211 | 0.2% |
| Other values (589) | 84662 |
| Value | Count | Frequency (%) |
| 1 | 156 | |
| 2 | 175 | |
| 3 | 144 | |
| 4 | 121 | |
| 5 | 175 | |
| 6 | 171 | |
| 7 | 191 | |
| 8 | 152 | |
| 9 | 122 | |
| 10 | 123 |
| Value | Count | Frequency (%) |
| 599 | 102 | |
| 598 | 102 | |
| 597 | 139 | |
| 596 | 154 | |
| 595 | 141 | |
| 594 | 141 | |
| 593 | 129 | |
| 592 | 139 | |
| 591 | 120 | |
| 590 | 129 |
cust_fn
Text
| Distinct | 591 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
Length
| Max length | 11 |
|---|---|
| Median length | 10 |
| Mean length | 5.6722471 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CHARLOTTE |
|---|---|
| 2nd row | CHARLOTTE |
| 3rd row | CHARLOTTE |
| 4th row | CHARLOTTE |
| 5th row | TOMMY |
| Value | Count | Frequency (%) |
| marion | 385 | 0.4% |
| leslie | 325 | 0.4% |
| tracy | 298 | 0.3% |
| terry | 282 | 0.3% |
| willie | 280 | 0.3% |
| jamie | 277 | 0.3% |
| jessie | 276 | 0.3% |
| eleanor | 272 | 0.3% |
| kelly | 272 | 0.3% |
| karl | 251 | 0.3% |
| Other values (581) | 84053 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 62268 | |
| A | 60578 | |
| R | 46544 | 9.4% |
| N | 42296 | 8.6% |
| I | 38227 | 7.7% |
| L | 36270 | 7.4% |
| O | 23170 | 4.7% |
| T | 21174 | 4.3% |
| S | 19394 | 3.9% |
| D | 18697 | 3.8% |
| Other values (16) | 124703 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 493321 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 62268 | |
| A | 60578 | |
| R | 46544 | 9.4% |
| N | 42296 | 8.6% |
| I | 38227 | 7.7% |
| L | 36270 | 7.4% |
| O | 23170 | 4.7% |
| T | 21174 | 4.3% |
| S | 19394 | 3.9% |
| D | 18697 | 3.8% |
| Other values (16) | 124703 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 493321 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 62268 | |
| A | 60578 | |
| R | 46544 | 9.4% |
| N | 42296 | 8.6% |
| I | 38227 | 7.7% |
| L | 36270 | 7.4% |
| O | 23170 | 4.7% |
| T | 21174 | 4.3% |
| S | 19394 | 3.9% |
| D | 18697 | 3.8% |
| Other values (16) | 124703 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 493321 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 62268 | |
| A | 60578 | |
| R | 46544 | 9.4% |
| N | 42296 | 8.6% |
| I | 38227 | 7.7% |
| L | 36270 | 7.4% |
| O | 23170 | 4.7% |
| T | 21174 | 4.3% |
| S | 19394 | 3.9% |
| D | 18697 | 3.8% |
| Other values (16) | 124703 |
cust_ln
Text
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
Length
| Max length | 12 |
|---|---|
| Median length | 10 |
| Mean length | 6.1929609 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | HUNTER |
|---|---|
| 2nd row | HUNTER |
| 3rd row | HUNTER |
| 4th row | HUNTER |
| 5th row | COLLAZO |
| Value | Count | Frequency (%) |
| hunt | 272 | 0.3% |
| seal | 251 | 0.3% |
| peters | 244 | 0.3% |
| shaw | 239 | 0.3% |
| dean | 225 | 0.3% |
| douglas | 221 | 0.3% |
| hernandez | 217 | 0.2% |
| snyder | 217 | 0.2% |
| sanders | 212 | 0.2% |
| seward | 211 | 0.2% |
| Other values (589) | 84662 |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 57552 | 10.7% |
| R | 53721 | 10.0% |
| A | 46896 | 8.7% |
| N | 42993 | 8.0% |
| O | 38448 | 7.1% |
| L | 38183 | 7.1% |
| S | 35551 | 6.6% |
| I | 26602 | 4.9% |
| T | 25723 | 4.8% |
| H | 19807 | 3.7% |
| Other values (16) | 153132 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 538608 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 57552 | 10.7% |
| R | 53721 | 10.0% |
| A | 46896 | 8.7% |
| N | 42993 | 8.0% |
| O | 38448 | 7.1% |
| L | 38183 | 7.1% |
| S | 35551 | 6.6% |
| I | 26602 | 4.9% |
| T | 25723 | 4.8% |
| H | 19807 | 3.7% |
| Other values (16) | 153132 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 538608 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 57552 | 10.7% |
| R | 53721 | 10.0% |
| A | 46896 | 8.7% |
| N | 42993 | 8.0% |
| O | 38448 | 7.1% |
| L | 38183 | 7.1% |
| S | 35551 | 6.6% |
| I | 26602 | 4.9% |
| T | 25723 | 4.8% |
| H | 19807 | 3.7% |
| Other values (16) | 153132 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 538608 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 57552 | 10.7% |
| R | 53721 | 10.0% |
| A | 46896 | 8.7% |
| N | 42993 | 8.0% |
| O | 38448 | 7.1% |
| L | 38183 | 7.1% |
| S | 35551 | 6.6% |
| I | 26602 | 4.9% |
| T | 25723 | 4.8% |
| H | 19807 | 3.7% |
| Other values (16) | 153132 |
email
Text
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
Length
| Max length | 40 |
|---|---|
| Median length | 38 |
| Mean length | 31.865208 |
| Min length | 26 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | CHARLOTTE.HUNTER@sakilacustomer.org |
|---|---|
| 2nd row | CHARLOTTE.HUNTER@sakilacustomer.org |
| 3rd row | CHARLOTTE.HUNTER@sakilacustomer.org |
| 4th row | CHARLOTTE.HUNTER@sakilacustomer.org |
| 5th row | TOMMY.COLLAZO@sakilacustomer.org |
| Value | Count | Frequency (%) |
| eleanor.hunt@sakilacustomer.org | 272 | 0.3% |
| karl.seal@sakilacustomer.org | 251 | 0.3% |
| sue.peters@sakilacustomer.org | 244 | 0.3% |
| clara.shaw@sakilacustomer.org | 239 | 0.3% |
| marcia.dean@sakilacustomer.org | 225 | 0.3% |
| marsha.douglas@sakilacustomer.org | 221 | 0.3% |
| angela.hernandez@sakilacustomer.org | 217 | 0.2% |
| marion.snyder@sakilacustomer.org | 217 | 0.2% |
| tammy.sanders@sakilacustomer.org | 212 | 0.2% |
| leslie.seward@sakilacustomer.org | 211 | 0.2% |
| Other values (589) | 84662 |
Most occurring characters
| Value | Count | Frequency (%) |
| r | 173942 | 6.3% |
| . | 173942 | 6.3% |
| o | 173942 | 6.3% |
| s | 173942 | 6.3% |
| a | 173942 | 6.3% |
| E | 119820 | 4.3% |
| A | 107474 | 3.9% |
| R | 100265 | 3.6% |
| l | 86971 | 3.1% |
| g | 86971 | 3.1% |
| Other values (31) | 1400138 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1478507 | |
| Uppercase Letter | 1031929 | |
| Other Punctuation | 260913 | 9.4% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 119820 | |
| A | 107474 | 10.4% |
| R | 100265 | 9.7% |
| N | 85289 | 8.3% |
| L | 74453 | 7.2% |
| I | 64829 | 6.3% |
| O | 61618 | 6.0% |
| S | 54945 | 5.3% |
| T | 46897 | 4.5% |
| C | 35920 | 3.5% |
| Other values (16) | 280419 |
Lowercase Letter
| Value | Count | Frequency (%) |
| r | 173942 | |
| o | 173942 | |
| s | 173942 | |
| a | 173942 | |
| l | 86971 | 5.9% |
| g | 86971 | 5.9% |
| e | 86971 | 5.9% |
| t | 86971 | 5.9% |
| u | 86971 | 5.9% |
| c | 86971 | 5.9% |
| Other values (3) | 260913 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 173942 | |
| @ | 86971 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 2510436 | |
| Common | 260913 | 9.4% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| r | 173942 | 6.9% |
| o | 173942 | 6.9% |
| s | 173942 | 6.9% |
| a | 173942 | 6.9% |
| E | 119820 | 4.8% |
| A | 107474 | 4.3% |
| R | 100265 | 4.0% |
| l | 86971 | 3.5% |
| g | 86971 | 3.5% |
| e | 86971 | 3.5% |
| Other values (29) | 1226196 |
Common
| Value | Count | Frequency (%) |
| . | 173942 | |
| @ | 86971 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2771349 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| r | 173942 | 6.3% |
| . | 173942 | 6.3% |
| o | 173942 | 6.3% |
| s | 173942 | 6.3% |
| a | 173942 | 6.3% |
| E | 119820 | 4.3% |
| A | 107474 | 3.9% |
| R | 100265 | 3.6% |
| l | 86971 | 3.1% |
| g | 86971 | 3.1% |
| Other values (31) | 1400138 |
active
Categorical
Imbalance
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
| 1 | |
|---|---|
| 0 | 2242 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 84729 | |
| 0 | 2242 | 2.6% |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 84729 | |
| 0 | 2242 | 2.6% |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 84729 | |
| 0 | 2242 | 2.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 86971 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 84729 | |
| 0 | 2242 | 2.6% |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 86971 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 84729 | |
| 0 | 2242 | 2.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 86971 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 84729 | |
| 0 | 2242 | 2.6% |
rental_id
Real number (ℝ)
| Distinct | 15821 |
|---|---|
| Distinct (%) | 18.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 7969.3271 |
| Minimum | 1 |
|---|---|
| Maximum | 16049 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 811 |
| Q1 | 3983 |
| median | 7948 |
| Q3 | 11918.5 |
| 95-th percentile | 15222.5 |
| Maximum | 16049 |
| Range | 16048 |
| Interquartile range (IQR) | 7935.5 |
Descriptive statistics
| Standard deviation | 4615.1429 |
|---|---|
| Coefficient of variation (CV) | 0.57911325 |
| Kurtosis | -1.1897433 |
| Mean | 7969.3271 |
| Median Absolute Deviation (MAD) | 3968 |
| Skewness | 0.016729421 |
| Sum | 6.9310035 × 108 |
| Variance | 21299544 |
| Monotonicity | Increasing |
| Value | Count | Frequency (%) |
| 12701 | 15 | < 0.1% |
| 8014 | 15 | < 0.1% |
| 4845 | 15 | < 0.1% |
| 15187 | 15 | < 0.1% |
| 14200 | 15 | < 0.1% |
| 5221 | 15 | < 0.1% |
| 2796 | 15 | < 0.1% |
| 5930 | 15 | < 0.1% |
| 7446 | 15 | < 0.1% |
| 7152 | 15 | < 0.1% |
| Other values (15811) | 86821 |
| Value | Count | Frequency (%) |
| 1 | 4 | |
| 2 | 5 | |
| 3 | 2 | < 0.1% |
| 4 | 4 | |
| 5 | 8 | |
| 6 | 4 | |
| 7 | 6 | |
| 8 | 4 | |
| 9 | 3 | < 0.1% |
| 10 | 7 |
| Value | Count | Frequency (%) |
| 16049 | 6 | |
| 16048 | 2 | < 0.1% |
| 16047 | 7 | |
| 16046 | 5 | |
| 16045 | 5 | |
| 16044 | 5 | |
| 16043 | 7 | |
| 16042 | 3 | < 0.1% |
| 16041 | 6 | |
| 16040 | 8 |
rental_date
Date
| Distinct | 15774 |
|---|---|
| Distinct (%) | 18.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
| Minimum | 2005-05-24 22:53:30 |
|---|---|
| Maximum | 2005-08-23 22:50:12 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
return_date
Date
| Distinct | 15796 |
|---|---|
| Distinct (%) | 18.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
| Minimum | 2005-05-25 23:55:21 |
|---|---|
| Maximum | 2005-09-02 02:35:22 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
payment_id
Real number (ℝ)
High correlation
| Distinct | 15821 |
|---|---|
| Distinct (%) | 18.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 8028.9088 |
| Minimum | 1 |
|---|---|
| Maximum | 16049 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 798 |
| Q1 | 4038 |
| median | 8040 |
| Q3 | 12028 |
| 95-th percentile | 15217 |
| Maximum | 16049 |
| Range | 16048 |
| Interquartile range (IQR) | 7990 |
Descriptive statistics
| Standard deviation | 4625.7166 |
|---|---|
| Coefficient of variation (CV) | 0.57613266 |
| Kurtosis | -1.1973239 |
| Mean | 8028.9088 |
| Median Absolute Deviation (MAD) | 3994 |
| Skewness | -0.0075447733 |
| Sum | 6.9828223 × 108 |
| Variance | 21397254 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 13202 | 15 | < 0.1% |
| 288 | 15 | < 0.1% |
| 14839 | 15 | < 0.1% |
| 12463 | 15 | < 0.1% |
| 9457 | 15 | < 0.1% |
| 2280 | 15 | < 0.1% |
| 5662 | 15 | < 0.1% |
| 6853 | 15 | < 0.1% |
| 13129 | 15 | < 0.1% |
| 10004 | 15 | < 0.1% |
| Other values (15811) | 86821 |
| Value | Count | Frequency (%) |
| 1 | 4 | |
| 2 | 5 | |
| 3 | 1 | < 0.1% |
| 4 | 3 | |
| 5 | 1 | < 0.1% |
| 6 | 6 | |
| 7 | 4 | |
| 8 | 6 | |
| 9 | 5 | |
| 10 | 5 |
| Value | Count | Frequency (%) |
| 16049 | 4 | |
| 16048 | 8 | |
| 16047 | 5 | |
| 16046 | 4 | |
| 16045 | 3 | < 0.1% |
| 16044 | 5 | |
| 16043 | 3 | < 0.1% |
| 16042 | 5 | |
| 16041 | 9 | |
| 16040 | 6 |
amount
Real number (ℝ)
High correlation
| Distinct | 12 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.1929297 |
| Minimum | 0.99 |
|---|---|
| Maximum | 11.99 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 0.99 |
|---|---|
| 5-th percentile | 0.99 |
| Q1 | 2.99 |
| median | 3.99 |
| Q3 | 4.99 |
| 95-th percentile | 8.99 |
| Maximum | 11.99 |
| Range | 11 |
| Interquartile range (IQR) | 2 |
Descriptive statistics
| Standard deviation | 2.3424864 |
|---|---|
| Coefficient of variation (CV) | 0.55867534 |
| Kurtosis | -0.24019559 |
| Mean | 4.1929297 |
| Median Absolute Deviation (MAD) | 1 |
| Skewness | 0.47005036 |
| Sum | 364663.29 |
| Variance | 5.4872427 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 4.99 | 20213 | |
| 2.99 | 19666 | |
| 0.99 | 15965 | |
| 5.99 | 7181 | 8.3% |
| 3.99 | 6340 | 7.3% |
| 6.99 | 5929 | 6.8% |
| 7.99 | 3654 | 4.2% |
| 1.99 | 3490 | 4.0% |
| 8.99 | 2633 | 3.0% |
| 9.99 | 1302 | 1.5% |
| Other values (2) | 598 | 0.7% |
| Value | Count | Frequency (%) |
| 0.99 | 15965 | |
| 1.99 | 3490 | 4.0% |
| 2.99 | 19666 | |
| 3.99 | 6340 | 7.3% |
| 4.99 | 20213 | |
| 5.99 | 7181 | 8.3% |
| 6.99 | 5929 | 6.8% |
| 7.99 | 3654 | 4.2% |
| 8.99 | 2633 | 3.0% |
| 9.99 | 1302 | 1.5% |
| Value | Count | Frequency (%) |
| 11.99 | 49 | 0.1% |
| 10.99 | 549 | 0.6% |
| 9.99 | 1302 | 1.5% |
| 8.99 | 2633 | 3.0% |
| 7.99 | 3654 | 4.2% |
| 6.99 | 5929 | 6.8% |
| 5.99 | 7181 | 8.3% |
| 4.99 | 20213 | |
| 3.99 | 6340 | 7.3% |
| 2.99 | 19666 |
payment_date
Date
| Distinct | 15774 |
|---|---|
| Distinct (%) | 18.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
| Minimum | 2005-05-24 22:53:30 |
|---|---|
| Maximum | 2005-08-23 22:50:12 |
| Invalid dates | 0 |
| Invalid dates (%) | 0.0% |
inventory_id
Real number (ℝ)
High correlation
| Distinct | 4567 |
|---|---|
| Distinct (%) | 5.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2297.3186 |
| Minimum | 1 |
|---|---|
| Maximum | 4581 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 214 |
| Q1 | 1160 |
| median | 2289 |
| Q3 | 3428 |
| 95-th percentile | 4368 |
| Maximum | 4581 |
| Range | 4580 |
| Interquartile range (IQR) | 2268 |
Descriptive statistics
| Standard deviation | 1320.7305 |
|---|---|
| Coefficient of variation (CV) | 0.57490088 |
| Kurtosis | -1.1807221 |
| Mean | 2297.3186 |
| Median Absolute Deviation (MAD) | 1132 |
| Skewness | -0.0074845396 |
| Sum | 1.9980009 × 108 |
| Variance | 1744329 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 1122 | 65 | 0.1% |
| 1123 | 65 | 0.1% |
| 2424 | 60 | 0.1% |
| 158 | 60 | 0.1% |
| 2423 | 60 | 0.1% |
| 1899 | 60 | 0.1% |
| 4095 | 60 | 0.1% |
| 2371 | 60 | 0.1% |
| 2337 | 60 | 0.1% |
| 2963 | 55 | 0.1% |
| Other values (4557) | 86366 |
| Value | Count | Frequency (%) |
| 1 | 30 | |
| 2 | 50 | |
| 3 | 20 | < 0.1% |
| 4 | 20 | < 0.1% |
| 6 | 40 | |
| 7 | 40 | |
| 8 | 20 | < 0.1% |
| 9 | 4 | < 0.1% |
| 10 | 12 | < 0.1% |
| 11 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 4581 | 15 | |
| 4580 | 6 | < 0.1% |
| 4579 | 15 | |
| 4578 | 9 | < 0.1% |
| 4577 | 15 | |
| 4576 | 12 | |
| 4575 | 12 | |
| 4574 | 9 | < 0.1% |
| 4573 | 25 | |
| 4572 | 20 |
store_id
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
| 1 | |
|---|---|
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 47427 | |
| 2 | 39544 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 47427 | |
| 2 | 39544 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 47427 | |
| 2 | 39544 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 86971 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 47427 | |
| 2 | 39544 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 86971 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 47427 | |
| 2 | 39544 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 86971 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 47427 | |
| 2 | 39544 |
staff_id
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
| 1 | |
|---|---|
| 2 |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1 |
|---|---|
| 2nd row | 1 |
| 3rd row | 1 |
| 4th row | 1 |
| 5th row | 1 |
Common Values
| Value | Count | Frequency (%) |
| 1 | 47427 | |
| 2 | 39544 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| 1 | 47427 | |
| 2 | 39544 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1 | 47427 | |
| 2 | 39544 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 86971 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 47427 | |
| 2 | 39544 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 86971 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 1 | 47427 | |
| 2 | 39544 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 86971 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1 | 47427 | |
| 2 | 39544 |
staff_fn
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
| Mike | |
|---|---|
| Jon |
Length
| Max length | 4 |
|---|---|
| Median length | 4 |
| Mean length | 3.5453197 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Mike |
|---|---|
| 2nd row | Mike |
| 3rd row | Mike |
| 4th row | Mike |
| 5th row | Mike |
Common Values
| Value | Count | Frequency (%) |
| Mike | 47427 | |
| Jon | 39544 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| mike | 47427 | |
| jon | 39544 |
Most occurring characters
| Value | Count | Frequency (%) |
| M | 47427 | |
| i | 47427 | |
| k | 47427 | |
| e | 47427 | |
| J | 39544 | |
| o | 39544 | |
| n | 39544 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 221369 | |
| Uppercase Letter | 86971 | 28.2% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 47427 | |
| k | 47427 | |
| e | 47427 | |
| o | 39544 | |
| n | 39544 |
Uppercase Letter
| Value | Count | Frequency (%) |
| M | 47427 | |
| J | 39544 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 308340 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| M | 47427 | |
| i | 47427 | |
| k | 47427 | |
| e | 47427 | |
| J | 39544 | |
| o | 39544 | |
| n | 39544 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 308340 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| M | 47427 | |
| i | 47427 | |
| k | 47427 | |
| e | 47427 | |
| J | 39544 | |
| o | 39544 | |
| n | 39544 |
staff_ln
Categorical
High correlation
| Distinct | 2 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
| Hillyer | |
|---|---|
| Stephens |
Length
| Max length | 8 |
|---|---|
| Median length | 7 |
| Mean length | 7.4546803 |
| Min length | 7 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Hillyer |
|---|---|
| 2nd row | Hillyer |
| 3rd row | Hillyer |
| 4th row | Hillyer |
| 5th row | Hillyer |
Common Values
| Value | Count | Frequency (%) |
| Hillyer | 47427 | |
| Stephens | 39544 |
Length
Common Values (Plot)
| Value | Count | Frequency (%) |
| hillyer | 47427 | |
| stephens | 39544 |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 126515 | |
| l | 94854 | |
| H | 47427 | 7.3% |
| i | 47427 | 7.3% |
| y | 47427 | 7.3% |
| r | 47427 | 7.3% |
| S | 39544 | 6.1% |
| t | 39544 | 6.1% |
| p | 39544 | 6.1% |
| h | 39544 | 6.1% |
| Other values (2) | 79088 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 561370 | |
| Uppercase Letter | 86971 | 13.4% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 126515 | |
| l | 94854 | |
| i | 47427 | 8.4% |
| y | 47427 | 8.4% |
| r | 47427 | 8.4% |
| t | 39544 | 7.0% |
| p | 39544 | 7.0% |
| h | 39544 | 7.0% |
| n | 39544 | 7.0% |
| s | 39544 | 7.0% |
Uppercase Letter
| Value | Count | Frequency (%) |
| H | 47427 | |
| S | 39544 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 648341 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 126515 | |
| l | 94854 | |
| H | 47427 | 7.3% |
| i | 47427 | 7.3% |
| y | 47427 | 7.3% |
| r | 47427 | 7.3% |
| S | 39544 | 6.1% |
| t | 39544 | 6.1% |
| p | 39544 | 6.1% |
| h | 39544 | 6.1% |
| Other values (2) | 79088 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 648341 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 126515 | |
| l | 94854 | |
| H | 47427 | 7.3% |
| i | 47427 | 7.3% |
| y | 47427 | 7.3% |
| r | 47427 | 7.3% |
| S | 39544 | 6.1% |
| t | 39544 | 6.1% |
| p | 39544 | 6.1% |
| h | 39544 | 6.1% |
| Other values (2) | 79088 |
address_id
Real number (ℝ)
High correlation
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 302.02316 |
| Minimum | 5 |
|---|---|
| Maximum | 605 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 5 |
|---|---|
| 5-th percentile | 33 |
| Q1 | 152 |
| median | 301 |
| Q3 | 451 |
| 95-th percentile | 574 |
| Maximum | 605 |
| Range | 600 |
| Interquartile range (IQR) | 299 |
Descriptive statistics
| Standard deviation | 172.81561 |
|---|---|
| Coefficient of variation (CV) | 0.57219324 |
| Kurtosis | -1.1881586 |
| Mean | 302.02316 |
| Median Absolute Deviation (MAD) | 149 |
| Skewness | 0.0090934767 |
| Sum | 26267256 |
| Variance | 29865.234 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 152 | 272 | 0.3% |
| 532 | 251 | 0.3% |
| 201 | 244 | 0.3% |
| 148 | 239 | 0.3% |
| 240 | 225 | 0.3% |
| 262 | 221 | 0.3% |
| 33 | 217 | 0.2% |
| 182 | 217 | 0.2% |
| 79 | 212 | 0.2% |
| 511 | 211 | 0.2% |
| Other values (589) | 84662 |
| Value | Count | Frequency (%) |
| 5 | 156 | |
| 6 | 175 | |
| 7 | 144 | |
| 8 | 121 | |
| 9 | 175 | |
| 10 | 171 | |
| 11 | 191 | |
| 12 | 152 | |
| 13 | 122 | |
| 14 | 123 |
| Value | Count | Frequency (%) |
| 605 | 102 | |
| 604 | 102 | |
| 603 | 139 | |
| 602 | 154 | |
| 601 | 141 | |
| 600 | 141 | |
| 599 | 129 | |
| 598 | 139 | |
| 597 | 120 | |
| 596 | 129 |
address
Text
| Distinct | 599 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
Length
| Max length | 38 |
|---|---|
| Median length | 34 |
| Mean length | 19.466282 |
| Min length | 9 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 758 Junan Lane |
|---|---|
| 2nd row | 758 Junan Lane |
| 3rd row | 758 Junan Lane |
| 4th row | 758 Junan Lane |
| 5th row | 76 Kermanshah Manor |
| Value | Count | Frequency (%) |
| parkway | 10989 | 3.8% |
| manor | 9773 | 3.4% |
| avenue | 8832 | 3.1% |
| way | 8767 | 3.1% |
| lane | 8635 | 3.0% |
| street | 8561 | 3.0% |
| place | 8117 | 2.8% |
| loop | 7980 | 2.8% |
| boulevard | 7724 | 2.7% |
| drive | 7593 | 2.7% |
| Other values (957) | 198978 |
Most occurring characters
| Value | Count | Frequency (%) |
| 198978 | 11.8% | |
| a | 176965 | 10.5% |
| e | 108940 | 6.4% |
| o | 86169 | 5.1% |
| r | 82593 | 4.9% |
| n | 81151 | 4.8% |
| 1 | 66932 | 4.0% |
| i | 50997 | 3.0% |
| l | 50634 | 3.0% |
| u | 48441 | 2.9% |
| Other values (56) | 741202 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 993631 | |
| Decimal Number | 296082 | 17.5% |
| Space Separator | 198978 | 11.8% |
| Uppercase Letter | 196522 | 11.6% |
| Dash Punctuation | 3471 | 0.2% |
| Open Punctuation | 2159 | 0.1% |
| Close Punctuation | 2159 | 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 176965 | |
| e | 108940 | |
| o | 86169 | 8.7% |
| r | 82593 | 8.3% |
| n | 81151 | 8.2% |
| i | 50997 | 5.1% |
| l | 50634 | 5.1% |
| u | 48441 | 4.9% |
| t | 40896 | 4.1% |
| y | 29143 | 2.9% |
| Other values (16) | 237702 |
Uppercase Letter
| Value | Count | Frequency (%) |
| P | 26280 | |
| L | 21774 | |
| S | 21644 | |
| B | 18284 | |
| A | 17157 | |
| M | 15102 | 7.7% |
| D | 10399 | 5.3% |
| W | 9368 | 4.8% |
| C | 9033 | 4.6% |
| T | 6459 | 3.3% |
| Other values (16) | 41022 |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 66932 | |
| 6 | 29227 | |
| 4 | 28644 | |
| 9 | 27998 | |
| 7 | 26263 | 8.9% |
| 8 | 25982 | 8.8% |
| 5 | 24591 | 8.3% |
| 2 | 24226 | 8.2% |
| 3 | 23063 | 7.8% |
| 0 | 19156 | 6.5% |
Space Separator
| Value | Count | Frequency (%) |
| 198978 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3471 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 2159 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 2159 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1190153 | |
| Common | 502849 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 176965 | |
| e | 108940 | 9.2% |
| o | 86169 | 7.2% |
| r | 82593 | 6.9% |
| n | 81151 | 6.8% |
| i | 50997 | 4.3% |
| l | 50634 | 4.3% |
| u | 48441 | 4.1% |
| t | 40896 | 3.4% |
| y | 29143 | 2.4% |
| Other values (42) | 434224 |
Common
| Value | Count | Frequency (%) |
| 198978 | ||
| 1 | 66932 | 13.3% |
| 6 | 29227 | 5.8% |
| 4 | 28644 | 5.7% |
| 9 | 27998 | 5.6% |
| 7 | 26263 | 5.2% |
| 8 | 25982 | 5.2% |
| 5 | 24591 | 4.9% |
| 2 | 24226 | 4.8% |
| 3 | 23063 | 4.6% |
| Other values (4) | 26945 | 5.4% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1693002 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 198978 | 11.8% | |
| a | 176965 | 10.5% |
| e | 108940 | 6.4% |
| o | 86169 | 5.1% |
| r | 82593 | 4.9% |
| n | 81151 | 4.8% |
| 1 | 66932 | 4.0% |
| i | 50997 | 3.0% |
| l | 50634 | 3.0% |
| u | 48441 | 2.9% |
| Other values (56) | 741202 |
postal_code
Real number (ℝ)
| Distinct | 596 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 50317.771 |
| Minimum | 3 |
|---|---|
| Maximum | 99865 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 3 |
|---|---|
| 5-th percentile | 4855 |
| Q1 | 25220 |
| median | 50805 |
| Q3 | 74750 |
| 95-th percentile | 95509 |
| Maximum | 99865 |
| Range | 99862 |
| Interquartile range (IQR) | 49530 |
Descriptive statistics
| Standard deviation | 28850.283 |
|---|---|
| Coefficient of variation (CV) | 0.57336171 |
| Kurtosis | -1.1649044 |
| Mean | 50317.771 |
| Median Absolute Deviation (MAD) | 24704 |
| Skewness | -0.017702468 |
| Sum | 4.3761869 × 109 |
| Variance | 8.3233886 × 108 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 52137 | 294 | 0.3% |
| 9668 | 284 | 0.3% |
| 92150 | 272 | 0.3% |
| 22474 | 270 | 0.3% |
| 31342 | 251 | 0.3% |
| 89459 | 244 | 0.3% |
| 30861 | 239 | 0.3% |
| 18727 | 225 | 0.3% |
| 86768 | 221 | 0.3% |
| 65750 | 217 | 0.2% |
| Other values (586) | 84454 |
| Value | Count | Frequency (%) |
| 3 | 116 | |
| 400 | 138 | |
| 504 | 130 | |
| 841 | 101 | |
| 943 | 133 | |
| 966 | 114 | |
| 1027 | 124 | |
| 1079 | 122 | |
| 1195 | 146 | |
| 1545 | 190 |
| Value | Count | Frequency (%) |
| 99865 | 126 | |
| 99780 | 165 | |
| 99552 | 140 | |
| 99457 | 168 | |
| 99405 | 178 | |
| 99124 | 119 | |
| 98889 | 141 | |
| 98883 | 157 | |
| 98775 | 121 | |
| 98573 | 148 |
city_id
Real number (ℝ)
| Distinct | 597 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 301.5238 |
| Minimum | 1 |
|---|---|
| Maximum | 600 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 31 |
| Q1 | 148 |
| median | 305 |
| Q3 | 452 |
| 95-th percentile | 569 |
| Maximum | 600 |
| Range | 599 |
| Interquartile range (IQR) | 304 |
Descriptive statistics
| Standard deviation | 173.42494 |
|---|---|
| Coefficient of variation (CV) | 0.5751617 |
| Kurtosis | -1.2093799 |
| Mean | 301.5238 |
| Median Absolute Deviation (MAD) | 151 |
| Skewness | -0.016446523 |
| Sum | 26223826 |
| Variance | 30076.209 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 442 | 272 | 0.3% |
| 42 | 263 | 0.3% |
| 312 | 258 | 0.3% |
| 101 | 251 | 0.3% |
| 109 | 244 | 0.3% |
| 340 | 239 | 0.3% |
| 527 | 225 | 0.3% |
| 64 | 221 | 0.3% |
| 474 | 217 | 0.2% |
| 456 | 217 | 0.2% |
| Other values (587) | 84564 |
| Value | Count | Frequency (%) |
| 1 | 153 | |
| 2 | 120 | |
| 3 | 175 | |
| 4 | 160 | |
| 5 | 124 | |
| 6 | 123 | |
| 7 | 178 | |
| 8 | 136 | |
| 9 | 164 | |
| 10 | 157 |
| Value | Count | Frequency (%) |
| 600 | 131 | |
| 599 | 162 | |
| 598 | 157 | |
| 597 | 138 | |
| 596 | 153 | |
| 595 | 81 | |
| 594 | 123 | |
| 593 | 144 | |
| 592 | 139 | |
| 591 | 124 |
city
Text
| Distinct | 597 |
|---|---|
| Distinct (%) | 0.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
Length
| Max length | 26 |
|---|---|
| Median length | 21 |
| Mean length | 8.3927286 |
| Min length | 2 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | guas Lindas de Gois |
|---|---|
| 2nd row | guas Lindas de Gois |
| 3rd row | guas Lindas de Gois |
| 4th row | guas Lindas de Gois |
| 5th row | Qomsheh |
| Value | Count | Frequency (%) |
| de | 1903 | 1.8% |
| san | 946 | 0.9% |
| la | 724 | 0.7% |
| del | 581 | 0.5% |
| santa | 575 | 0.5% |
| el | 433 | 0.4% |
| hill | 404 | 0.4% |
| santiago | 395 | 0.4% |
| plata | 353 | 0.3% |
| felipe | 344 | 0.3% |
| Other values (673) | 99477 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 108294 | 14.8% |
| n | 51398 | 7.0% |
| o | 47215 | 6.5% |
| i | 45992 | 6.3% |
| e | 42212 | 5.8% |
| r | 37947 | 5.2% |
| u | 33842 | 4.6% |
| l | 30043 | 4.1% |
| s | 24579 | 3.4% |
| t | 24408 | 3.3% |
| Other values (47) | 283994 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 598395 | |
| Uppercase Letter | 105377 | 14.4% |
| Space Separator | 19164 | 2.6% |
| Dash Punctuation | 3828 | 0.5% |
| Open Punctuation | 1501 | 0.2% |
| Close Punctuation | 1501 | 0.2% |
| Other Punctuation | 158 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 108294 | |
| n | 51398 | 8.6% |
| o | 47215 | 7.9% |
| i | 45992 | 7.7% |
| e | 42212 | 7.1% |
| r | 37947 | 6.3% |
| u | 33842 | 5.7% |
| l | 30043 | 5.0% |
| s | 24579 | 4.1% |
| t | 24408 | 4.1% |
| Other values (16) | 152465 |
Uppercase Letter
| Value | Count | Frequency (%) |
| S | 13137 | 12.5% |
| B | 9526 | 9.0% |
| C | 7163 | 6.8% |
| A | 7133 | 6.8% |
| P | 6253 | 5.9% |
| T | 6165 | 5.9% |
| K | 5864 | 5.6% |
| M | 5717 | 5.4% |
| L | 5133 | 4.9% |
| H | 4290 | 4.1% |
| Other values (16) | 34996 |
Space Separator
| Value | Count | Frequency (%) |
| 19164 |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 3828 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 1501 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 1501 |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 158 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 703772 | |
| Common | 26152 | 3.6% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 108294 | |
| n | 51398 | 7.3% |
| o | 47215 | 6.7% |
| i | 45992 | 6.5% |
| e | 42212 | 6.0% |
| r | 37947 | 5.4% |
| u | 33842 | 4.8% |
| l | 30043 | 4.3% |
| s | 24579 | 3.5% |
| t | 24408 | 3.5% |
| Other values (42) | 257842 |
Common
| Value | Count | Frequency (%) |
| 19164 | ||
| - | 3828 | 14.6% |
| ( | 1501 | 5.7% |
| ) | 1501 | 5.7% |
| / | 158 | 0.6% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 729924 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 108294 | 14.8% |
| n | 51398 | 7.0% |
| o | 47215 | 6.5% |
| i | 45992 | 6.3% |
| e | 42212 | 5.8% |
| r | 37947 | 5.2% |
| u | 33842 | 4.6% |
| l | 30043 | 4.1% |
| s | 24579 | 3.4% |
| t | 24408 | 3.3% |
| Other values (47) | 283994 |
country_id
Real number (ℝ)
| Distinct | 108 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 56.890297 |
| Minimum | 1 |
|---|---|
| Maximum | 109 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 679.6 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 29 |
| median | 50 |
| Q3 | 80 |
| 95-th percentile | 103 |
| Maximum | 109 |
| Range | 108 |
| Interquartile range (IQR) | 51 |
Descriptive statistics
| Standard deviation | 30.050282 |
|---|---|
| Coefficient of variation (CV) | 0.52821454 |
| Kurtosis | -1.1593477 |
| Mean | 56.890297 |
| Median Absolute Deviation (MAD) | 27 |
| Skewness | 0.054671729 |
| Sum | 4947806 |
| Variance | 903.01946 |
| Monotonicity | Not monotonic |
| Value | Count | Frequency (%) |
| 44 | 8502 | 9.8% |
| 23 | 7638 | 8.8% |
| 103 | 5363 | 6.2% |
| 50 | 4504 | 5.2% |
| 60 | 4469 | 5.1% |
| 15 | 4000 | 4.6% |
| 80 | 3877 | 4.5% |
| 75 | 3100 | 3.6% |
| 97 | 2077 | 2.4% |
| 45 | 2001 | 2.3% |
| Other values (98) | 41440 |
| Value | Count | Frequency (%) |
| 1 | 109 | 0.1% |
| 2 | 443 | 0.5% |
| 3 | 111 | 0.1% |
| 4 | 301 | 0.3% |
| 5 | 195 | 0.2% |
| 6 | 1841 | |
| 7 | 149 | 0.2% |
| 9 | 403 | 0.5% |
| 10 | 300 | 0.3% |
| 11 | 129 | 0.1% |
| Value | Count | Frequency (%) |
| 109 | 171 | 0.2% |
| 108 | 328 | 0.4% |
| 107 | 621 | 0.7% |
| 106 | 190 | 0.2% |
| 105 | 892 | 1.0% |
| 104 | 953 | 1.1% |
| 103 | 5363 | |
| 102 | 1188 | 1.4% |
| 101 | 474 | 0.5% |
| 100 | 823 | 0.9% |
country
Text
| Distinct | 108 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
Length
| Max length | 37 |
|---|---|
| Median length | 29 |
| Mean length | 8.1399892 |
| Min length | 4 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Brazil |
|---|---|
| 2nd row | Brazil |
| 3rd row | Brazil |
| 4th row | Brazil |
| 5th row | Iran |
| Value | Count | Frequency (%) |
| india | 8502 | 8.0% |
| china | 7638 | 7.2% |
| united | 7025 | 6.6% |
| states | 5363 | 5.0% |
| japan | 4504 | 4.2% |
| mexico | 4469 | 4.2% |
| brazil | 4000 | 3.8% |
| russian | 3877 | 3.6% |
| federation | 3877 | 3.6% |
| philippines | 3100 | 2.9% |
| Other values (122) | 54236 |
Most occurring characters
| Value | Count | Frequency (%) |
| a | 94530 | 13.4% |
| i | 79564 | 11.2% |
| n | 71781 | 10.1% |
| e | 57603 | 8.1% |
| t | 35126 | 5.0% |
| r | 30693 | 4.3% |
| d | 29861 | 4.2% |
| o | 26184 | 3.7% |
| s | 24857 | 3.5% |
| l | 19770 | 2.8% |
| Other values (44) | 237974 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 581080 | |
| Uppercase Letter | 106019 | 15.0% |
| Space Separator | 19620 | 2.8% |
| Other Punctuation | 818 | 0.1% |
| Open Punctuation | 203 | < 0.1% |
| Close Punctuation | 203 | < 0.1% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| a | 94530 | |
| i | 79564 | |
| n | 71781 | |
| e | 57603 | |
| t | 35126 | 6.0% |
| r | 30693 | 5.3% |
| d | 29861 | 5.1% |
| o | 26184 | 4.5% |
| s | 24857 | 4.3% |
| l | 19770 | 3.4% |
| Other values (16) | 111111 |
Uppercase Letter
| Value | Count | Frequency (%) |
| I | 13788 | |
| S | 11152 | |
| C | 10935 | |
| U | 8038 | 7.6% |
| A | 6615 | 6.2% |
| M | 6504 | 6.1% |
| P | 6468 | 6.1% |
| B | 5737 | 5.4% |
| R | 5676 | 5.4% |
| T | 5413 | 5.1% |
| Other values (13) | 25693 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 438 | |
| . | 380 |
Space Separator
| Value | Count | Frequency (%) |
| 19620 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 203 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 203 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 687099 | |
| Common | 20844 | 2.9% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| a | 94530 | |
| i | 79564 | 11.6% |
| n | 71781 | 10.4% |
| e | 57603 | 8.4% |
| t | 35126 | 5.1% |
| r | 30693 | 4.5% |
| d | 29861 | 4.3% |
| o | 26184 | 3.8% |
| s | 24857 | 3.6% |
| l | 19770 | 2.9% |
| Other values (39) | 217130 |
Common
| Value | Count | Frequency (%) |
| 19620 | ||
| , | 438 | 2.1% |
| . | 380 | 1.8% |
| ( | 203 | 1.0% |
| ) | 203 | 1.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 707943 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| a | 94530 | 13.4% |
| i | 79564 | 11.2% |
| n | 71781 | 10.1% |
| e | 57603 | 8.1% |
| t | 35126 | 5.0% |
| r | 30693 | 4.3% |
| d | 29861 | 4.2% |
| o | 26184 | 3.7% |
| s | 24857 | 3.5% |
| l | 19770 | 2.8% |
| Other values (44) | 237974 |
category
Categorical
| Distinct | 16 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 679.6 KiB |
| Sports | |
|---|---|
| Animation | |
| Action | |
| Documentary | |
| Drama | |
| Other values (11) |
Length
| Max length | 11 |
|---|---|
| Median length | 9 |
| Mean length | 6.534339 |
| Min length | 3 |
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Family |
|---|---|
| 2nd row | Family |
| 3rd row | Family |
| 4th row | Family |
| 5th row | Music |
Common Values
| Value | Count | Frequency (%) |
| Sports | 6861 | 7.9% |
| Animation | 6479 | 7.4% |
| Action | 6204 | 7.1% |
| Documentary | 6139 | 7.1% |
| Drama | 5886 | 6.8% |
| Sci-Fi | 5695 | 6.5% |
| Family | 5544 | 6.4% |
| Foreign | 5516 | 6.3% |
| Children | 5473 | 6.3% |
| New | 5131 | 5.9% |
| Other values (6) | 28043 |
Length
| Value | Count | Frequency (%) |
| sports | 6861 | 7.9% |
| animation | 6479 | 7.4% |
| action | 6204 | 7.1% |
| documentary | 6139 | 7.1% |
| drama | 5886 | 6.8% |
| sci-fi | 5695 | 6.5% |
| family | 5544 | 6.4% |
| foreign | 5516 | 6.3% |
| children | 5473 | 6.3% |
| new | 5131 | 5.9% |
| Other values (6) | 28043 |
Most occurring characters
| Value | Count | Frequency (%) |
| i | 56567 | 10.0% |
| r | 49023 | 8.6% |
| o | 45518 | 8.0% |
| a | 44068 | 7.8% |
| n | 36290 | 6.4% |
| e | 35971 | 6.3% |
| m | 33159 | 5.8% |
| s | 30919 | 5.4% |
| c | 27520 | 4.8% |
| t | 25683 | 4.5% |
| Other values (20) | 183580 |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 469937 | |
| Uppercase Letter | 92666 | 16.3% |
| Dash Punctuation | 5695 | 1.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| i | 56567 | |
| r | 49023 | |
| o | 45518 | |
| a | 44068 | |
| n | 36290 | |
| e | 35971 | |
| m | 33159 | 7.1% |
| s | 30919 | 6.6% |
| c | 27520 | 5.9% |
| t | 25683 | 5.5% |
| Other values (9) | 85219 |
Uppercase Letter
| Value | Count | Frequency (%) |
| F | 16755 | |
| C | 15137 | |
| A | 12683 | |
| S | 12556 | |
| D | 12025 | |
| N | 5131 | 5.5% |
| H | 4849 | 5.2% |
| T | 4601 | 5.0% |
| G | 4490 | 4.8% |
| M | 4439 | 4.8% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 5695 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 562603 | |
| Common | 5695 | 1.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| i | 56567 | 10.1% |
| r | 49023 | 8.7% |
| o | 45518 | 8.1% |
| a | 44068 | 7.8% |
| n | 36290 | 6.5% |
| e | 35971 | 6.4% |
| m | 33159 | 5.9% |
| s | 30919 | 5.5% |
| c | 27520 | 4.9% |
| t | 25683 | 4.6% |
| Other values (19) | 177885 |
Common
| Value | Count | Frequency (%) |
| - | 5695 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 568298 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| i | 56567 | 10.0% |
| r | 49023 | 8.6% |
| o | 45518 | 8.0% |
| a | 44068 | 7.8% |
| n | 36290 | 6.4% |
| e | 35971 | 6.3% |
| m | 33159 | 5.8% |
| s | 30919 | 5.4% |
| c | 27520 | 4.8% |
| t | 25683 | 4.5% |
| Other values (20) | 183580 |
Interactions
Correlations
| active | actor_id | address_id | amount | category | city_id | country_id | customer_id | film_id | inventory_id | length | payment_id | postal_code | rating | rental_duration | rental_id | rental_rate | replacement_cost | staff_fn | staff_id | staff_ln | store_id | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| active | 1.000 | 0.000 | 0.085 | 0.029 | 0.032 | 0.109 | 0.093 | 0.093 | 0.023 | 0.022 | 0.029 | 0.092 | 0.138 | 0.015 | 0.010 | 0.022 | 0.007 | 0.019 | 0.003 | 0.003 | 0.003 | 0.003 |
| actor_id | 0.000 | 1.000 | 0.001 | -0.007 | 0.056 | 0.002 | 0.002 | 0.001 | 0.015 | 0.015 | 0.015 | 0.001 | 0.003 | 0.043 | 0.041 | -0.003 | 0.043 | -0.002 | 0.000 | 0.000 | 0.000 | 0.000 |
| address_id | 0.085 | 0.001 | 1.000 | 0.015 | 0.032 | 0.041 | -0.042 | 1.000 | -0.004 | -0.004 | -0.015 | 1.000 | -0.043 | 0.020 | 0.028 | -0.003 | 0.027 | -0.023 | 0.075 | 0.075 | 0.075 | 0.075 |
| amount | 0.029 | -0.007 | 0.015 | 1.000 | 0.068 | 0.001 | 0.012 | 0.015 | 0.027 | 0.027 | 0.003 | 0.015 | -0.012 | 0.033 | 0.178 | 0.011 | 0.716 | -0.031 | 0.018 | 0.018 | 0.018 | 0.018 |
| category | 0.032 | 0.056 | 0.032 | 0.068 | 1.000 | 0.034 | 0.030 | 0.032 | 0.139 | 0.138 | 0.148 | 0.031 | 0.029 | 0.156 | 0.161 | 0.024 | 0.146 | 0.140 | 0.032 | 0.032 | 0.032 | 0.032 |
| city_id | 0.109 | 0.002 | 0.041 | 0.001 | 0.034 | 1.000 | -0.058 | 0.041 | 0.010 | 0.010 | -0.002 | 0.041 | -0.070 | 0.020 | 0.021 | -0.004 | 0.026 | -0.001 | 0.106 | 0.106 | 0.106 | 0.106 |
| country_id | 0.093 | 0.002 | -0.042 | 0.012 | 0.030 | -0.058 | 1.000 | -0.042 | 0.017 | 0.017 | 0.011 | -0.042 | 0.001 | 0.025 | 0.022 | -0.004 | 0.020 | 0.003 | 0.102 | 0.102 | 0.102 | 0.102 |
| customer_id | 0.093 | 0.001 | 1.000 | 0.015 | 0.032 | 0.041 | -0.042 | 1.000 | -0.004 | -0.004 | -0.015 | 1.000 | -0.043 | 0.019 | 0.029 | -0.003 | 0.027 | -0.023 | 0.074 | 0.074 | 0.074 | 0.074 |
| film_id | 0.023 | 0.015 | -0.004 | 0.027 | 0.139 | 0.010 | 0.017 | -0.004 | 1.000 | 1.000 | 0.053 | -0.004 | -0.008 | 0.120 | 0.112 | -0.001 | 0.113 | -0.040 | 0.033 | 0.033 | 0.033 | 0.033 |
| inventory_id | 0.022 | 0.015 | -0.004 | 0.027 | 0.138 | 0.010 | 0.017 | -0.004 | 1.000 | 1.000 | 0.053 | -0.004 | -0.008 | 0.119 | 0.112 | -0.001 | 0.116 | -0.040 | 0.032 | 0.032 | 0.032 | 0.032 |
| length | 0.029 | 0.015 | -0.015 | 0.003 | 0.148 | -0.002 | 0.011 | -0.015 | 0.053 | 0.053 | 1.000 | -0.015 | -0.004 | 0.101 | 0.087 | 0.002 | 0.105 | 0.015 | 0.017 | 0.017 | 0.017 | 0.017 |
| payment_id | 0.092 | 0.001 | 1.000 | 0.015 | 0.031 | 0.041 | -0.042 | 1.000 | -0.004 | -0.004 | -0.015 | 1.000 | -0.043 | 0.018 | 0.028 | -0.001 | 0.026 | -0.023 | 0.073 | 0.073 | 0.073 | 0.073 |
| postal_code | 0.138 | 0.003 | -0.043 | -0.012 | 0.029 | -0.070 | 0.001 | -0.043 | -0.008 | -0.008 | -0.004 | -0.043 | 1.000 | 0.016 | 0.017 | 0.005 | 0.027 | -0.002 | 0.091 | 0.091 | 0.091 | 0.091 |
| rating | 0.015 | 0.043 | 0.020 | 0.033 | 0.156 | 0.020 | 0.025 | 0.019 | 0.120 | 0.119 | 0.101 | 0.018 | 0.016 | 1.000 | 0.096 | 0.019 | 0.039 | 0.112 | 0.016 | 0.016 | 0.016 | 0.016 |
| rental_duration | 0.010 | 0.041 | 0.028 | 0.178 | 0.161 | 0.021 | 0.022 | 0.029 | 0.112 | 0.112 | 0.087 | 0.028 | 0.017 | 0.096 | 1.000 | 0.021 | 0.072 | 0.083 | 0.006 | 0.006 | 0.006 | 0.006 |
| rental_id | 0.022 | -0.003 | -0.003 | 0.011 | 0.024 | -0.004 | -0.004 | -0.003 | -0.001 | -0.001 | 0.002 | -0.001 | 0.005 | 0.019 | 0.021 | 1.000 | 0.024 | 0.006 | 0.028 | 0.028 | 0.028 | 0.028 |
| rental_rate | 0.007 | 0.043 | 0.027 | 0.716 | 0.146 | 0.026 | 0.020 | 0.027 | 0.113 | 0.116 | 0.105 | 0.026 | 0.027 | 0.039 | 0.072 | 0.024 | 1.000 | 0.109 | 0.000 | 0.000 | 0.000 | 0.000 |
| replacement_cost | 0.019 | -0.002 | -0.023 | -0.031 | 0.140 | -0.001 | 0.003 | -0.023 | -0.040 | -0.040 | 0.015 | -0.023 | -0.002 | 0.112 | 0.083 | 0.006 | 0.109 | 1.000 | 0.027 | 0.027 | 0.027 | 0.027 |
| staff_fn | 0.003 | 0.000 | 0.075 | 0.018 | 0.032 | 0.106 | 0.102 | 0.074 | 0.033 | 0.032 | 0.017 | 0.073 | 0.091 | 0.016 | 0.006 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
| staff_id | 0.003 | 0.000 | 0.075 | 0.018 | 0.032 | 0.106 | 0.102 | 0.074 | 0.033 | 0.032 | 0.017 | 0.073 | 0.091 | 0.016 | 0.006 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
| staff_ln | 0.003 | 0.000 | 0.075 | 0.018 | 0.032 | 0.106 | 0.102 | 0.074 | 0.033 | 0.032 | 0.017 | 0.073 | 0.091 | 0.016 | 0.006 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
| store_id | 0.003 | 0.000 | 0.075 | 0.018 | 0.032 | 0.106 | 0.102 | 0.074 | 0.033 | 0.032 | 0.017 | 0.073 | 0.091 | 0.016 | 0.006 | 0.028 | 0.000 | 0.027 | 1.000 | 1.000 | 1.000 | 1.000 |
Missing values
Sample
| film_id | title | description | rental_duration | rental_rate | length | replacement_cost | rating | actor_id | actor_fn | actor_ln | customer_id | cust_fn | cust_ln | active | rental_id | rental_date | return_date | payment_id | amount | payment_date | inventory_id | store_id | staff_id | staff_fn | staff_ln | address_id | address | postal_code | city_id | city | country_id | country | category | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 80 | BLANKET BEVERLY | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria | 7 | 2.99 | 148 | 21.99 | G | 16 | FRED | COSTNER | 130 | CHARLOTTE | HUNTER | CHARLOTTE.HUNTER@sakilacustomer.org | 1 | 1 | 2005-05-24 22:53:30.000 | 2005-05-26 22:04:30.000 | 3504 | 2.99 | 2005-05-24 22:53:30.000 | 367 | 1 | 1 | Mike | Hillyer | 134 | 758 Junan Lane | 82639 | 190 | guas Lindas de Gois | 15 | Brazil | Family |
| 1 | 80 | BLANKET BEVERLY | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria | 7 | 2.99 | 148 | 21.99 | G | 173 | ALAN | DREYFUSS | 130 | CHARLOTTE | HUNTER | CHARLOTTE.HUNTER@sakilacustomer.org | 1 | 1 | 2005-05-24 22:53:30.000 | 2005-05-26 22:04:30.000 | 3504 | 2.99 | 2005-05-24 22:53:30.000 | 367 | 1 | 1 | Mike | Hillyer | 134 | 758 Junan Lane | 82639 | 190 | guas Lindas de Gois | 15 | Brazil | Family |
| 2 | 80 | BLANKET BEVERLY | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria | 7 | 2.99 | 148 | 21.99 | G | 193 | BURT | TEMPLE | 130 | CHARLOTTE | HUNTER | CHARLOTTE.HUNTER@sakilacustomer.org | 1 | 1 | 2005-05-24 22:53:30.000 | 2005-05-26 22:04:30.000 | 3504 | 2.99 | 2005-05-24 22:53:30.000 | 367 | 1 | 1 | Mike | Hillyer | 134 | 758 Junan Lane | 82639 | 190 | guas Lindas de Gois | 15 | Brazil | Family |
| 3 | 80 | BLANKET BEVERLY | A Emotional Documentary of a Student And a Girl who must Build a Boat in Nigeria | 7 | 2.99 | 148 | 21.99 | G | 200 | THORA | TEMPLE | 130 | CHARLOTTE | HUNTER | CHARLOTTE.HUNTER@sakilacustomer.org | 1 | 1 | 2005-05-24 22:53:30.000 | 2005-05-26 22:04:30.000 | 3504 | 2.99 | 2005-05-24 22:53:30.000 | 367 | 1 | 1 | Mike | Hillyer | 134 | 758 Junan Lane | 82639 | 190 | guas Lindas de Gois | 15 | Brazil | Family |
| 4 | 333 | FREAKY POCUS | A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico | 7 | 2.99 | 126 | 16.99 | R | 42 | TOM | MIRANDA | 459 | TOMMY | COLLAZO | TOMMY.COLLAZO@sakilacustomer.org | 1 | 2 | 2005-05-24 22:54:33.000 | 2005-05-28 19:40:33.000 | 12377 | 2.99 | 2005-05-24 22:54:33.000 | 1525 | 1 | 1 | Mike | Hillyer | 464 | 76 Kermanshah Manor | 23343 | 423 | Qomsheh | 46 | Iran | Music |
| 5 | 333 | FREAKY POCUS | A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico | 7 | 2.99 | 126 | 16.99 | R | 103 | MATTHEW | LEIGH | 459 | TOMMY | COLLAZO | TOMMY.COLLAZO@sakilacustomer.org | 1 | 2 | 2005-05-24 22:54:33.000 | 2005-05-28 19:40:33.000 | 12377 | 2.99 | 2005-05-24 22:54:33.000 | 1525 | 1 | 1 | Mike | Hillyer | 464 | 76 Kermanshah Manor | 23343 | 423 | Qomsheh | 46 | Iran | Music |
| 6 | 333 | FREAKY POCUS | A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico | 7 | 2.99 | 126 | 16.99 | R | 105 | SIDNEY | CROWE | 459 | TOMMY | COLLAZO | TOMMY.COLLAZO@sakilacustomer.org | 1 | 2 | 2005-05-24 22:54:33.000 | 2005-05-28 19:40:33.000 | 12377 | 2.99 | 2005-05-24 22:54:33.000 | 1525 | 1 | 1 | Mike | Hillyer | 464 | 76 Kermanshah Manor | 23343 | 423 | Qomsheh | 46 | Iran | Music |
| 7 | 333 | FREAKY POCUS | A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico | 7 | 2.99 | 126 | 16.99 | R | 127 | KEVIN | GARLAND | 459 | TOMMY | COLLAZO | TOMMY.COLLAZO@sakilacustomer.org | 1 | 2 | 2005-05-24 22:54:33.000 | 2005-05-28 19:40:33.000 | 12377 | 2.99 | 2005-05-24 22:54:33.000 | 1525 | 1 | 1 | Mike | Hillyer | 464 | 76 Kermanshah Manor | 23343 | 423 | Qomsheh | 46 | Iran | Music |
| 8 | 333 | FREAKY POCUS | A Fast-Paced Documentary of a Pastry Chef And a Crocodile who must Chase a Squirrel in The Gulf of Mexico | 7 | 2.99 | 126 | 16.99 | R | 147 | FAY | WINSLET | 459 | TOMMY | COLLAZO | TOMMY.COLLAZO@sakilacustomer.org | 1 | 2 | 2005-05-24 22:54:33.000 | 2005-05-28 19:40:33.000 | 12377 | 2.99 | 2005-05-24 22:54:33.000 | 1525 | 1 | 1 | Mike | Hillyer | 464 | 76 Kermanshah Manor | 23343 | 423 | Qomsheh | 46 | Iran | Music |
| 9 | 373 | GRADUATE LORD | A Lacklusture Epistle of a Girl And a A Shark who must Meet a Mad Scientist in Ancient China | 7 | 2.99 | 156 | 14.99 | G | 139 | EWAN | GOODING | 408 | MANUEL | MURRELL | MANUEL.MURRELL@sakilacustomer.org | 1 | 3 | 2005-05-24 23:03:39.000 | 2005-06-01 22:12:39.000 | 11032 | 3.99 | 2005-05-24 23:03:39.000 | 1711 | 1 | 1 | Mike | Hillyer | 413 | 692 Amroha Drive | 35575 | 230 | Jaffna | 88 | Sri Lanka | Children |
| film_id | title | description | rental_duration | rental_rate | length | replacement_cost | rating | actor_id | actor_fn | actor_ln | customer_id | cust_fn | cust_ln | active | rental_id | rental_date | return_date | payment_id | amount | payment_date | inventory_id | store_id | staff_id | staff_fn | staff_ln | address_id | address | postal_code | city_id | city | country_id | country | category | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 86961 | 452 | ILLUSION AMELIE | A Emotional Epistle of a Boat And a Mad Scientist who must Outrace a Robot in An Abandoned Mine Shaft | 4 | 0.99 | 122 | 15.99 | R | 133 | RICHARD | PENN | 114 | GRACE | ELLIS | GRACE.ELLIS@sakilacustomer.org | 1 | 16047 | 2005-08-23 22:42:48.000 | 2005-08-25 02:48:48.000 | 3089 | 0.99 | 2005-08-23 22:42:48.000 | 2088 | 2 | 2 | Jon | Stephens | 118 | 442 Rae Bareli Place | 24321 | 148 | Duisburg | 38 | Germany | Foreign |
| 86962 | 452 | ILLUSION AMELIE | A Emotional Epistle of a Boat And a Mad Scientist who must Outrace a Robot in An Abandoned Mine Shaft | 4 | 0.99 | 122 | 15.99 | R | 184 | HUMPHREY | GARLAND | 114 | GRACE | ELLIS | GRACE.ELLIS@sakilacustomer.org | 1 | 16047 | 2005-08-23 22:42:48.000 | 2005-08-25 02:48:48.000 | 3089 | 0.99 | 2005-08-23 22:42:48.000 | 2088 | 2 | 2 | Jon | Stephens | 118 | 442 Rae Bareli Place | 24321 | 148 | Duisburg | 38 | Germany | Foreign |
| 86963 | 439 | HUNCHBACK IMPOSSIBLE | A Touching Yarn of a Frisbee And a Dentist who must Fight a Composer in Ancient Japan | 4 | 4.99 | 151 | 28.99 | PG-13 | 106 | GROUCHO | DUNST | 103 | GLADYS | HAMILTON | GLADYS.HAMILTON@sakilacustomer.org | 1 | 16048 | 2005-08-23 22:43:07.000 | 2005-08-31 21:33:07.000 | 2799 | 8.99 | 2005-08-23 22:43:07.000 | 2019 | 1 | 1 | Mike | Hillyer | 107 | 1177 Jelets Way | 3305 | 220 | Ilorin | 69 | Nigeria | Drama |
| 86964 | 439 | HUNCHBACK IMPOSSIBLE | A Touching Yarn of a Frisbee And a Dentist who must Fight a Composer in Ancient Japan | 4 | 4.99 | 151 | 28.99 | PG-13 | 175 | WILLIAM | HACKMAN | 103 | GLADYS | HAMILTON | GLADYS.HAMILTON@sakilacustomer.org | 1 | 16048 | 2005-08-23 22:43:07.000 | 2005-08-31 21:33:07.000 | 2799 | 8.99 | 2005-08-23 22:43:07.000 | 2019 | 1 | 1 | Mike | Hillyer | 107 | 1177 Jelets Way | 3305 | 220 | Ilorin | 69 | Nigeria | Drama |
| 86965 | 585 | MOB DUFFEL | A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies | 4 | 0.99 | 105 | 25.99 | G | 24 | CAMERON | STREEP | 393 | PHILIP | CAUSEY | PHILIP.CAUSEY@sakilacustomer.org | 1 | 16049 | 2005-08-23 22:50:12.000 | 2005-08-30 01:01:12.000 | 10671 | 3.99 | 2005-08-23 22:50:12.000 | 2666 | 1 | 1 | Mike | Hillyer | 398 | 954 Lapu-Lapu Way | 8816 | 278 | Korolev | 80 | Russian Federation | Drama |
| 86966 | 585 | MOB DUFFEL | A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies | 4 | 0.99 | 105 | 25.99 | G | 31 | SISSY | SOBIESKI | 393 | PHILIP | CAUSEY | PHILIP.CAUSEY@sakilacustomer.org | 1 | 16049 | 2005-08-23 22:50:12.000 | 2005-08-30 01:01:12.000 | 10671 | 3.99 | 2005-08-23 22:50:12.000 | 2666 | 1 | 1 | Mike | Hillyer | 398 | 954 Lapu-Lapu Way | 8816 | 278 | Korolev | 80 | Russian Federation | Drama |
| 86967 | 585 | MOB DUFFEL | A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies | 4 | 0.99 | 105 | 25.99 | G | 32 | TIM | HACKMAN | 393 | PHILIP | CAUSEY | PHILIP.CAUSEY@sakilacustomer.org | 1 | 16049 | 2005-08-23 22:50:12.000 | 2005-08-30 01:01:12.000 | 10671 | 3.99 | 2005-08-23 22:50:12.000 | 2666 | 1 | 1 | Mike | Hillyer | 398 | 954 Lapu-Lapu Way | 8816 | 278 | Korolev | 80 | Russian Federation | Drama |
| 86968 | 585 | MOB DUFFEL | A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies | 4 | 0.99 | 105 | 25.99 | G | 61 | CHRISTIAN | NEESON | 393 | PHILIP | CAUSEY | PHILIP.CAUSEY@sakilacustomer.org | 1 | 16049 | 2005-08-23 22:50:12.000 | 2005-08-30 01:01:12.000 | 10671 | 3.99 | 2005-08-23 22:50:12.000 | 2666 | 1 | 1 | Mike | Hillyer | 398 | 954 Lapu-Lapu Way | 8816 | 278 | Korolev | 80 | Russian Federation | Drama |
| 86969 | 585 | MOB DUFFEL | A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies | 4 | 0.99 | 105 | 25.99 | G | 103 | MATTHEW | LEIGH | 393 | PHILIP | CAUSEY | PHILIP.CAUSEY@sakilacustomer.org | 1 | 16049 | 2005-08-23 22:50:12.000 | 2005-08-30 01:01:12.000 | 10671 | 3.99 | 2005-08-23 22:50:12.000 | 2666 | 1 | 1 | Mike | Hillyer | 398 | 954 Lapu-Lapu Way | 8816 | 278 | Korolev | 80 | Russian Federation | Drama |
| 86970 | 585 | MOB DUFFEL | A Unbelieveable Documentary of a Frisbee And a Boat who must Meet a Boy in The Canadian Rockies | 4 | 0.99 | 105 | 25.99 | G | 106 | GROUCHO | DUNST | 393 | PHILIP | CAUSEY | PHILIP.CAUSEY@sakilacustomer.org | 1 | 16049 | 2005-08-23 22:50:12.000 | 2005-08-30 01:01:12.000 | 10671 | 3.99 | 2005-08-23 22:50:12.000 | 2666 | 1 | 1 | Mike | Hillyer | 398 | 954 Lapu-Lapu Way | 8816 | 278 | Korolev | 80 | Russian Federation | Drama |